Release 10.1A: OpenEdge Data Management:
DataServer for Microsoft SQL Server

Interaction of code page, collation, and case sensitivity

Properly setting code page, collation, and case sensitivity values such that they compliment each other, will yield the best scenarios for data access. To avoid conflict between code page, collation, and case sensitivity, set these characteristics at schema creation, and allow a schema pull to manage the DataServer integration. If any of these settings are changed, the schema holder should be regenerated. Table 2–3 describes the interaction between code page, collation, and case sensitivity.